-
Re: Ratio-Based Conditional Task Health Indicator
Here you go. I added the if it hasn't finished yet piece. =if(and(Finish@row <today(), [% Complete]@row <1), "Red", IF([% Complete]@row >= (0.75 * (TODAY() - Start@row) / (Finish@r…1 · -
Re: NEW! Dashboards Design Enhancements
Love the color updates! Why the rounding of corners on images though? I thought we might be able to push images together with no spacing but no dice.1 · -
Re: Automated emails are including data I don't want/need
Hey Kim, this might not be what you're going after, but here's both options: Custom Message This one removes all the stuff you didn't want to see and is formatted a little differently. I used @Frank …1 · -
Re: Trying to determine where we are in the process
Hey @LaB You're on the right track. You can use IF and AND to evaluate the columns, but work backwards. Try this one... =if(and([Step1]@row = "Yes", [Step2]@row = "Yes", [Step3]@r…1 · -
Re: Form -is there a way to display only available times (defined in drop down list) in the form
@JVL Like @Julie Fortney mentioned, Data Shuttle works great for this. If you don't have that DS add-on, I created a little Auto Updating Dropdown app that others have found useful. If you want to se…1 ·